package cn.gson.springboot.model.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.alibaba.fastjson.JSONArray;
//科室
@Mapper
public interface DepartmentsMapper {

	//id查询科室
	public JSONArray findByid(Integer did);
	
	//科室查询
	public JSONArray findDepartments();
	
	//科室查询
	public JSONArray findks(@Param("departments_name") String departments_name);
	
	//科室查询
	public JSONArray cxsyks();
	//查询该科室下的人员 
	public JSONArray findRoleAndDept(@Param("did")Integer did,
										@Param("rid")Integer rid);
	
	//查询该科室下的空床位 
	public JSONArray findBedByDept(Integer did);
	
	
	//<!-- 查询门诊处的所有科室 -->
	public  JSONArray  findMzks();
	
	//<!--门诊科室新增查询是否有相同的科室  -->
	public  JSONArray  mzaddks(@Param("departments_name") String departments_name);
	
	//<!--住院科室新增查询是否有相同的科室  -->
	public  JSONArray  zyaddks(@Param("departments_name") String departments_name);
}
